EPPS 6354 Assignment 6

Question 1:

Shopping websites I noticed used JSON, like kohls. Most pages with APIs to be used also were JSON as well. These were built with like databases like MongoDB. XML websites tended to be older websites from what I saw.

---

Question 2:

Using left join, original query chooses student ids for those without advisors.

select s.ID
from student s
left join advisor a
  on s.ID = a.s_ID
  and a.i_ID is not null
where a.s_ID is null;

select i.ID, i.name
from instructor i
join teaches t on i.ID = t.ID
join course c on t.course_id = c.course_id
where c.dept_name = i.dept_name
group by i.ID, i.name, i.dept_name
having count(distinct c.course_id) = (
    select count(*)
    from course c2
    where c2.dept_name = i.dept_name
)
order by i.name

---

Question 3:

Screenshots: